﻿<!DOCTYPE html>
<html>
<head>
    <meta charset="utf-8">
    <title>查看数据库表
    </title>
    <meta name="description" content="">
    <meta name="author" content="">

    <meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1.0, user-scalable=no">

    <!-- #CSS Links -->
    <!-- Basic Styles -->
    <link rel="stylesheet" type="text/css" media="screen" href="css/bootstrap.min.css">
    <link rel="stylesheet" type="text/css" media="screen" href="css/font-awesome.css">

    <!-- SmartAdmin Styles : Caution! DO NOT change the order -->
    <link rel="stylesheet" type="text/css" media="screen" href="css/smartadmin-production-plugins.css">
    <link rel="stylesheet" type="text/css" media="screen" href="css/smartadmin-production.css">
    <link rel="stylesheet" type="text/css" media="screen" href="css/smartadmin-skins.css">

    <!-- SmartAdmin RTL Support -->
    <link rel="stylesheet" type="text/css" media="screen" href="css/smartadmin-rtl.css">

    <!-- Demo purpose only: goes with demo.js, you can delete this css when designing your own WebApp -->
    <link rel="stylesheet" type="text/css" media="screen" href="css/demo.css">

    <!-- #FAVICONS -->
    <link rel="shortcut icon" href="img/favicon/favicon.ico" type="image/x-icon">
    <link rel="icon" href="img/favicon/favicon.ico" type="image/x-icon">

    <!-- #GOOGLE FONT -->
    <link rel="stylesheet" href="css/open-sans.css" type="text/css">

    <!-- #APP SCREEN / ICONS -->
    <link rel="apple-touch-icon" href="img/splash/sptouch-icon-iphone.png">
    <link rel="apple-touch-icon" sizes="76x76" href="img/splash/touch-icon-ipad.png">
    <link rel="apple-touch-icon" sizes="120x120" href="img/splash/touch-icon-iphone-retina.png">
    <link rel="apple-touch-icon" sizes="152x152" href="img/splash/touch-icon-ipad-retina.png">

    <!-- iOS web-app metas : hides Safari UI Components and Changes Status Bar Appearance -->
    <meta name="apple-mobile-web-app-capable" content="yes">
    <meta name="apple-mobile-web-app-status-bar-style" content="black">

    <!-- Startup image for web apps -->
    <link rel="apple-touch-startup-image" href="img/splash/ipad-landscape.png"
        media="screen and (min-device-width: 481px) and (max-device-width: 1024px) and (orientation:landscape)">
    <link rel="apple-touch-startup-image" href="img/splash/ipad-portrait.png"
        media="screen and (min-device-width: 481px) and (max-device-width: 1024px) and (orientation:portrait)">
    <link rel="apple-touch-startup-image" href="img/splash/iphone.png" media="screen and (max-device-width: 320px)">

    <link href="appcss/Common.css" rel="stylesheet" />
</head>
<body class="desktop-detected minified">

    <!-- #MAIN PANEL -->
    <div id="main" role="main">

        <!-- RIBBON -->
        <div id="ribbon">

            <span class="ribbon-button-alignment">
                <span class="btn btn-ribbon"><i class="fa fa-home"></i></span>
            </span>
            <!-- breadcrumb -->
            <ol class="breadcrumb">
                <li><a href="DataTableManagement.html">数据表管理</a></li>
                <li>查看数据库表</li>
            </ol>
            <!-- end breadcrumb -->

        </div>
        <!-- END RIBBON -->


        <!-- MAIN CONTENT -->
        <div id="content">
            <div class="row hidden">
                <div class="col-xs-12 col-sm-7 col-md-7 col-lg-4">
                    <h1 class="page-title txt-color-blueDark">
                        <i class="fa fa-edit fa-fw "></i>
                        主页
            <span>> 
				查看数据库表
            </span>
                    </h1>
                </div>
            </div>

            <!-- widget grid -->
            <section id="widget-grid" class="">

                <!-- row -->
                <div class="row">

                    <!-- NEW WIDGET START -->


                    <!-- NEW WIDGET START -->
                    <article class="col-sm-12 col-md-12 ">

                        <!-- Widget ID (each widget will need unique ID)-->
                        <div class="jarviswidget" id="wid-id-2" data-widget-colorbutton="false"
                            data-widget-editbutton="false">
                            <header>
                                <h2>查看数据库表</h2>

                            </header>

                            <!-- widget div-->
                            <div>

                                <!-- widget edit box -->
                                <div class="jarviswidget-editbox">
                                    <!-- This area used as dropdown edit box -->

                                </div>
                                <!-- end widget edit box -->

                                <!-- widget content -->
                                <div class="widget-body no-padding">

                                    <!-- Success states for elements -->

                                    <form action="" class="smart-form" id="Create-Form">

                                        <header>相关信息</header>
                                        <fieldset>

                                            <section>
                                                <label class="label">表名</label>
                                                <label class="input">
                                                    <input type="text" value="" name="tableName" id="tableName" disabled="disabled" />
                                                </label>
                                            </section>
                                            <section>
                                                <label class="label">创建时间</label>
                                                <label class="input">
                                                    <input type="text" value="" name="createTime" id="createTime" disabled="disabled" />
                                                </label>
                                            </section>
                                            <section>
                                                可追踪数据表
                                                <input type="checkbox" disabled="disabled" value="" id="isRawDt" name="isRawDt">
                                            </section>
                                            <section>
                                                <label class="label">数据源</label>
                                                <label class="input">
                                                    <table class="table table-bordered table-hover smart-form " id="table-source-details" style="width: 30%;">
                                                        <thead>
                                                            <tr>
                                                                <th>数据源名称</th>
                                                            </tr>
                                                        </thead>
                                                        <tbody>
                                                              <tr><td>数据加载中</tr>
                                                        </tbody>
                                                    </table>
                                                </label>
                                            </section>
                                            <section>
                                                <label class="label">数据源列数据</label>
                                                <table class="table table-bordered table-hover smart-form " id="table-column-details">
                                                    <thead>
                                                        <tr>
                                                            <th>主键</th>
                                                            <th>数据列</th>
                                                            <th>数据列类型</th>
                                                            <th>数据库列</th>
                                                            <th>数据库类型</th>
                                                            <th>数据库长度</th>
                                                            <th>数据库允许为空</th>
                                                            <th>创建时间</th>
                                                        </tr>
                                                    </thead>
                                                    <tbody>
                                                        <tr><td>数据加载中</tr>
                                                    </tbody>
                                                </table>
                                            </section>
                                        </fieldset>
                                        <footer>
                                            <button type="button" class="btn btn-default" onclick="window.history.back();">
                                                返回
                                            </button>
                                        </footer>

                                    </form>
                                    <!--/ Success states for elements -->
                                </div>
                                <!-- end widget content -->
                            </div>
                            <!-- end widget div -->
                        </div>
                        <!-- end widget -->
                    </article>
                </div>

                <!-- end row -->

            </section>
        </div>
        <!-- END MAIN CONTENT -->
    </div>

    <!--================================================== -->

    <!-- PACE LOADER - turn this on if you want ajax loading to show (caution: uses lots of memory on iDevices)
<script data-pace-options='{ "restartOnRequestAfter": true }' src="js/plugin/pace/pace.min.js"></script>-->


    <!-- #PLUGINS -->
    <!-- Link to Google CDN's jQuery + jQueryUI; fall back to local -->


    <script src="js/libs/jquery-2.1.1.min.js"></script>
    <script src="js/libs/jquery-ui-1.10.3.min.js"></script>
    <!-- BOOTSTRAP JS -->
    <script src="js/bootstrap/bootstrap.min.js"></script>

    <!-- IMPORTANT: APP CONFIG -->
    <script src="js/app.config.js"></script>


    <!-- CUSTOM NOTIFICATION -->
    <script src="js/notification/SmartNotification.min.js"></script>

    <!-- JARVIS WIDGETS -->
    <script src="js/smartwidgets/jarvis.widget.min.js"></script>


    <!-- SPARKLINES -->
    <script src="js/plugin/sparkline/jquery.sparkline.min.js"></script>

    <!-- JQUERY MASKED INPUT -->
    <script src="js/plugin/masked-input/jquery.maskedinput.min.js"></script>


    <!-- JQUERY UI + Bootstrap Slider -->
    <script src="js/plugin/bootstrap-slider/bootstrap-slider.min.js"></script>

    <script src="js/app.min.js"></script>
    <script src="appjs/Helper.js"></script>
    <script src="appjs/Common.js"></script>
    <script>
        var tableId = GetQueryString("tableId");
        var datasources;
        $(function () {
            //获取服务的详细信息
            var getServiceDetails = function () {
                $.ajax({
                    url: apiUrl,
                    data: {
                        "sys:sno": "ETL",
                        "sys:act": "GetDataTable",
                        "DataTableId": tableId
                    },
                    dataType: "json",
                    success: function (data) {
                        if (data.IsSccuess) {
                            $("#tableName").val(data.Data.Name);
                            $("#createTime").val(data.Data.CreatedTime);
                            $("#sourceName").val(data.Data.MappedDataSource);
                            if (data.Data.IsRawDt) {
                                $("#isRawDt").attr("checked", "checked");
                            }
                            // 
                            datasources = data.Data.DataSources;
                            $("#table-source-details tbody").html(assembleDataSourceData(data.Data.DataSources));
                            if (data.Data.DataSources.length > 0) {
                                $("#table-column-details tbody").html(assembleData(data.Data.DataSources[0].Columns));
                                $("#table-column-details").prev().html("数据源列数据(" + data.Data.DataSources[0].DataSourceName + ")");
                            }
                            bandclick();
                        } else {
                            if (IsLogined(data.ErrorCode)) {
                                alert("失败（" + "错误代码：" + data.ErrorCode + "，错误信息：" + data.Message + ")");
                            }
                        }
                    }
                });
               
            }
            getServiceDetails();
            var bandclick = function () {
                $(".table-source-details-td").click(function () {
                    var $this = $(this);
                    $("#table-column-details").prev().html("数据源列数据(" + $this.html() + ")");
                    if (datasources != undefined && datasources != null) {
                        for (var i = 0; i < datasources.length; i++) {
                            if (datasources[i].DataSourceId == $this.attr("data")) {
                                $("#table-column-details tbody").html(assembleData(datasources[i].Columns));
                            }
                        }
                    }
                });
            }
        });
        var assembleData = function (data) {
            var tr = "";
            for (var i = 0; i < data.length; i++) {
                tr += ("<tr >");
                tr += "<td>" + (data[i].IsDataIdentity ? "<input type='checkbox' checked='checked' disabled='disabled'/>" : "<input type='checkbox'  disabled='disabled'/>") + "</td>";
                tr += "<td>" + data[i].MappingColumnName + "</td>";
                tr += "<td>" + data[i].MappingColumnType + "</td>";
                tr += "<td>" + data[i].Name + "</td>";
                tr += "<td>" + data[i].Type + "</td>";
                tr += "<td>" + data[i].Length + "</td>";
                tr += "<td>" + (data[i].Nullable ? "是" : "否") + "</td>";
                tr += "<td>" + data[i].CreatedTime + "</td>";
                tr += ("</tr>");
            }
            return tr;
        }
        var assembleDataSourceData = function (data) {
            var tr = "";
            for (var i = 0; i < data.length; i++) {
                tr += ("<tr >");
                tr += "<td class='table-source-details-td' data='" + data[i].DataSourceId + "'>" + data[i].DataSourceName + "</td>";
                tr += ("</tr>");
            }
            return tr;
        }

    </script>

</body>
</html>
